df["period"] = df["Year"].astype(str) + df["quarter"]
df = pd.merge(df,df2[['Key_Column','Target_Column']],on='Key_Column', how='left')
df["period"] = df["Year"] + df["quarter"]